{% extends "base.html" %}
{% block title %}Asset Assignments{% endblock %}
{% block content %}

{% block subnav %}
	{% include "subnav.html" %}
{% endblock %}


{% if session['role'] == 'user' %}
<h1>Asset Assignments</h1>
{% elif session['role'] == 'manager' or session['role'] == 'admin' %}
<div class="d-flex justify-content-between align-items-center mt-3 mb-3">
	<h1>Asset Assignments</h1>
	<a href="#addAssignmentSection" id="toggleAddAssignmentBtn" class="btn btn-success"
	   data-bs-toggle="collapse" data-bs-target="#assignmentTable,#addAssignmentSection"
	   aria-expanded="false">
		<i class="bi bi-plus-circle"></i> Add Assignment
	</a>
</div>

{% with messages = get_flashed_messages(with_categories=true) %}
	{% if messages %}
		{% for category, msg in messages %}
			<div class="alert alert-{{ category }} mt-2">{{ msg }}</div>
		{% endfor %}
	{% endif %}
{% endwith %}

<!-- Add Assignment Section -->
<div class="collapse" id="addAssignmentSection">
	<h2>Add Asset Assignment</h2>

	<!-- CSV Upload -->
	<div class="card mb-4">
		<div class="card-body">
			<h5>Upload from CSV</h5>
			<form action="{{ url_for('asset_assignment.asset_assignments') }}" method="POST" enctype="multipart/form-data">
				<div class="mb-3">
					<input type="file" class="form-control" id="csv_file" name="csv_file" accept=".csv" required>
					<div class="form-text">Only .csv files are supported.</div>
				</div>
				<button type="submit" class="btn btn-primary">Upload CSV</button>
			</form>
		</div>
	</div>

	<div class="card mb-4">
		<div class="card-body">
			<form method="post">
				<div class="row g-3">
					<div class="col-md-6">
						<label for="asset_id" class="form-label">Asset *</label>
						<select id="asset_id" name="asset_id" class="form-select" required>
							{% for asset in assets %}
								<option value="{{ asset.asset_id }}">{{ asset.asset_tag }} - {{ asset.name }}</option>
							{% endfor %}
						</select>
					</div>

					<div class="col-md-6">
						<label for="employee_id" class="form-label">Employee *</label>
						<select id="employee_id" name="employee_id" class="form-select" required>
							{% for employee in employees %}
								<option value="{{ employee.employee_id }}">{{ employee.first_name }} {{ employee.last_name }}</option>
							{% endfor %}
						</select>
					</div>

					<div class="col-md-6">
						<label for="assigned_date" class="form-label">Assigned Date *</label>
						<input id="assigned_date" name="assigned_date" type="date" class="form-control" required>
					</div>

					<div class="col-md-6">
						<label for="returned_date" class="form-label">Returned Date</label>
						<input id="returned_date" name="returned_date" type="date" class="form-control">
					</div>
				</div>

				<div class="mt-4">
					<button type="submit" class="btn btn-success">Add Assignment</button>
				</div>
			</form>
		</div>
	</div>
</div>
{% endif %}


<!-- Assignment Table -->
<div class="collapse show" id="assignmentTable">

	<!-- Search Bar -->
	<form method="get" action="{{ url_for('asset_assignment.asset_assignments') }}" class="mb-3 d-flex">
	<input type="text" name="search" class="form-control me-2"
	       placeholder="Search asset assignments..."
	       value="{{ request.args.get('search', '') }}">
	<button type="submit" class="btn btn-primary">Search</button>
	</form>

	<table class="table table-striped align-middle">
		<thead class="table-light">
			<tr>
				{% set columns = [
					('assignment_id', 'ID'),
					('asset.asset_tag', 'Asset'),
					('employee.last_name', 'Employee'),
					('assigned_date', 'Assigned Date'),
					('returned_date', 'Returned Date')
				] %}
				{% for field, label in columns %}
					<th class="fw-bold text-nowrap">
						<a href="?sort={{ field }}&direction={{ 'desc' if sort == field and direction == 'asc' else 'asc' }}&search={{ request.args.get('search', '') }}"
   							class="text-dark text-decoration-none text-nowrap">
							{{ label }}
							{% if sort == field %}
								{{ '↑' if direction == 'asc' else '↓' }}
							{% endif %}
						</a>
					</th>
				{% endfor %}
				{% if session['role'] == 'manager' or session['role'] == 'admin' %}
				<th class="fw-bold text-nowrap">Actions</th>
				{% endif %}
			</tr>
		</thead>
		<tbody>
			{% for assignment in assignments %}
				<tr>
					<td>{{ assignment.assignment_id }}</td>
					<td><a href="{{ url_for('assets.assets', search=assignment.asset.asset_tag) }}">
						{{ assignment.asset.asset_tag }}
					</a></td>
					<td>{{ assignment.employee.first_name }} {{ assignment.employee.last_name }}</td>
					<td>{{ assignment.assigned_date }}</td>
					<td>{{ assignment.returned_date or '' }}</td>
					{% if session['role'] == 'manager' or session['role'] == 'admin' %}
					<td>
							<!-- Collapsible Button -->
						<a class="btn btn-sm btn-secondary"
						   data-bs-toggle="collapse"
						   href="#editAssetAssignment{{ assignment.assignment_id }}"
						   role="button"
						   aria-expanded="false"
						   aria-controls="editAssetAssignment{{ assignment.assignment_id }}">
							Edit
						</a>
						<!-- Delete Button -->
						<a href="/asset_assignments/delete/{{ assignment.assignment_id }}" class="btn btn-sm btn-danger">Delete</a>
					</td>
					{% endif %}
				</tr>

				<!-- Collapsible edit form row -->
				<tr class="collapse" id="editAssetAssignment{{ assignment.assignment_id }}">
					<td colspan="3">
						<div class="card card-body">
							<form method="post" action="/asset_assignments/edit/{{ assignment.assignment_id }}">
								<div class="row g-3">

									<!-- Asset selection -->
									<div class="col-md-6">
										<label for="asset_id_{{ assignment.assignment_id }}" class="form-label">Asset</label>
										<select id="asset_id_{{ assignment.assignment_id }}" name="asset_id" class="form-select" required>
											{% for asset in assets %}
												<option value="{{ asset.asset_id }}"
													{% if assignment.asset_id == asset.asset_id %}selected{% endif %}>
													{{ asset.asset_tag }} - {{ asset.name }}
												</option>
											{% endfor %}
										</select>
									</div>

									<!-- Employee selection -->
									<div class="col-md-6">
										<label for="employee_id_{{ assignment.assignment_id }}" class="form-label">Employee</label>
										<select id="employee_id_{{ assignment.assignment_id }}" name="employee_id" class="form-select" required>
											{% for emp in employees %}
												<option value="{{ emp.employee_id }}"
													{% if assignment.employee_id == emp.employee_id %}selected{% endif %}>
													{{ emp.first_name }} {{ emp.last_name }}
												</option>
											{% endfor %}
										</select>
									</div>

									<!-- Assigned date -->
									<div class="col-md-6">
										<label for="assigned_date_{{ assignment.assignment_id }}" class="form-label">Assigned Date</label>
										<input type="date" id="assigned_date_{{ assignment.assignment_id }}" name="assigned_date"
											   class="form-control" value="{{ assignment.assigned_date }}" required>
									</div>

									<!-- Returned date -->
									<div class="col-md-6">
										<label for="returned_date_{{ assignment.assignment_id }}" class="form-label">Returned Date</label>
										<input type="date" id="returned_date_{{ assignment.assignment_id }}" name="returned_date"
											   class="form-control" value="{{ assignment.returned_date or '' }}">
									</div>
								</div>

								<div class="mt-3">
									<button type="submit" class="btn btn-sm btn-success">Save</button>
								</div>
							</form>
						</div>
					</td>
				</tr>


			{% endfor %}
		</tbody>
	</table>
</div>

{% endblock %}